کوتاه کننده لینک بوم‌لاگ | Boomlog Link Shortener

CREATE TABLE [dbo].[tblLinkShortener](
	[lid] [bigint] IDENTITY(912,1) NOT NULL,
	[link] [nvarchar](500) NOT NULL,
	[requestTime] [datetime] NOT NULL,
	[expireTime] [datetime] NOT NULL,
	[status] [tinyint] NOT NULL,
 CONSTRAINT [PK_tblLinkShortener] PRIMARY KEY CLUSTERED 
(
	[lid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]


GO


CREATE PROCEDURE [dbo].[storeProcedure_tblLinkShortener_add]
      @lid bigint, 
      @link nvarchar(500), 
      @requestTime datetime, 
      @expireTime datetime, 
      @status tinyint
AS
BEGIN
	  IF NOT EXISTS (SELECT * FROM tblLinkShortener WHERE [link]=@link)
	  BEGIN
	      INSERT INTO tblLinkShortener ( [link], [requestTime], [expireTime], [status]) VALUES ( @link, @requestTime, @expireTime, @status)
		  SELECT SCOPE_IDENTITY()
	  END
	  ELSE
	  BEGIN
		  SELECT lid FROM tblLinkShortener WHERE [link]=@link
	  END
END
GO